Browsing Data Selected for a Conversion/Migration

DTS stores data that is selected for processing in a DTS cluster. Sometimes you might want to see this data, mainly for troubleshooting purposes by comparing data before and after a transformation. DTS offers two ways to display it:

  1. Directly from monitoring the execution – see the chapter Execute and Monitor Transformation. The selection screen shown after you click Display cluster data is described in the Browsing individual tables section below.

  2. By executing the report /DVD/ERP_CLU_DATA_BROWSER. The report shows a selection screen with the following options:

    • Run ID: Specifies the DTS run ID for which clusters will be browsed.

    • Table: Specifies the table name from the DTS table pool.

    • Partition ID: Restricts the displayed partition ID. Data from other partitions will not be displayed. See also the Conversion partition checkbox below.

    • Conversion partition: Related to the partition ID. If selected, the partition ID parameter refers to the conversion partition. If left empty, the parallel read partition is considered.

    • Package: Splits a conversion partition into packages. This option allows you to restrict the selection by specific DTS packages.

    • Delta run number: In the case of the NZD scenario, this parameter allows you to define restrictions for the specific delta run.

 

Browsing individual tables

After you select the table, a selection screen with table fields and restrictions for DTS clusters is displayed:

  • Select options for the table fields: Standard SE16-like options for selecting the individual table fields.

  • The Restriction area contains the following options:

    • Partition ID: See the Partition ID description above.

    • Read partition/Conversion partition: See the Conversion partition checkbox above.

    • Package: See the Package description above.

    • No. of records: Maximum number of displayed records.